Limitations and considerations
When using IBM Informix as a database in a Replicate task, the following limitations currently apply:
-
CDC does not capture DDL changes. Due to an IBM Informix limitation, IBM Informix does not allow DDLs to be executed on tables with Full Row Logging enabled.
To learn how to capture DDL changes during CDC, see Automatically enable full row logging.
-
Due to an IBM Informix limitation, columns that follow columns of data types SET,MULTISET or LIST will not be replicated during CDC.
For example, in the table below, changes to Col3 will not be captured during CDC.
Example table Name Data Type Col1
INTEGER
Col2
SET
Col3
INTEGER
-
User-defined data types are not supported.
-
Start from timestamp is not supported.
Information noteChoosing this option will resume the task from the current time.
- If a task with an IBM Informix source is stopped before any changes have been made and then resumed, any changes that were made between the time that the task was stopped and the time that it was resumed will be lost.
- Due to a known issue with the IBM Informix CDC API, Replicate does not support replication of tables whose names contain spaces or non-English letters.
- All transactions should be manually stopped before starting a Full Load task. Transactions started during the Full Load operation will be cached.
- FIELDPROC and EDITPROC are not supported during CDC.
-
Replication from an IBM Informix High Availability cluster is not supported.
-
Replicating data with 4-byte emoji characters is not supported.